Overview

Dataset statistics

Number of variables18
Number of observations8950
Missing cells314
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 MiB
Average record size in memory144.0 B

Variable types

NUM17
CAT1

Warnings

ONEOFF_PURCHASES is highly correlated with PURCHASESHigh correlation
PURCHASES is highly correlated with ONEOFF_PURCHASESHigh correlation
MINIMUM_PAYMENTS has 313 (3.5%) missing values Missing
CUST_ID has unique values Unique
PURCHASES has 2044 (22.8%) zeros Zeros
ONEOFF_PURCHASES has 4302 (48.1%) zeros Zeros
INSTALLMENTS_PURCHASES has 3916 (43.8%) zeros Zeros
CASH_ADVANCE has 4628 (51.7%) zeros Zeros
PURCHASES_FREQUENCY has 2043 (22.8%) zeros Zeros
ONEOFF_PURCHASES_FREQUENCY has 4302 (48.1%) zeros Zeros
PURCHASES_INSTALLMENTS_FREQUENCY has 3915 (43.7%) zeros Zeros
CASH_ADVANCE_FREQUENCY has 4628 (51.7%) zeros Zeros
CASH_ADVANCE_TRX has 4628 (51.7%) zeros Zeros
PURCHASES_TRX has 2044 (22.8%) zeros Zeros
PAYMENTS has 240 (2.7%) zeros Zeros
PRC_FULL_PAYMENT has 5903 (66.0%) zeros Zeros

Reproduction

Analysis started2021-05-23 02:41:05.973684
Analysis finished2021-05-23 02:41:59.088628
Duration53.11 seconds
Software versionpandas-profiling v2.9.0
Download configurationconfig.yaml

Variables

CUST_ID
Categorical

UNIQUE

Distinct8950
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size69.9 KiB
C13569
 
1
C15541
 
1
C10338
 
1
C11689
 
1
C18571
 
1
Other values (8945)
8945 
ValueCountFrequency (%) 
C135691< 0.1%
 
C155411< 0.1%
 
C103381< 0.1%
 
C116891< 0.1%
 
C185711< 0.1%
 
C109561< 0.1%
 
C166351< 0.1%
 
C110621< 0.1%
 
C107381< 0.1%
 
C171481< 0.1%
 
Other values (8940)894099.9%
 
2021-05-22T22:41:59.258441image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Frequencies of value counts

Unique

Unique8950 ?
Unique (%)100.0%
2021-05-22T22:41:59.394462image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length6
Median length6
Mean length6
Min length6

BALANCE
Real number (ℝ≥0)

Distinct8871
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1564.474828
Minimum0
Maximum19043.13856
Zeros80
Zeros (%)0.9%
Memory size69.9 KiB
2021-05-22T22:41:59.529043image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile8.81451835
Q1128.2819155
median873.385231
Q32054.140036
95-th percentile5909.111808
Maximum19043.13856
Range19043.13856
Interquartile range (IQR)1925.85812

Descriptive statistics

Standard deviation2081.531879
Coefficient of variation (CV)1.330498799
Kurtosis7.6747513
Mean1564.474828
Median Absolute Deviation (MAD)799.865197
Skewness2.393386043
Sum14002049.71
Variance4332774.965
MonotocityNot monotonic
2021-05-22T22:41:59.690354image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0800.9%
 
1100.9410721< 0.1%
 
40.0744841< 0.1%
 
2093.8446561< 0.1%
 
179.7657081< 0.1%
 
12.6549031< 0.1%
 
1893.7048511< 0.1%
 
1571.2186951< 0.1%
 
31.2856081< 0.1%
 
1772.3234911< 0.1%
 
Other values (8861)886199.0%
 
ValueCountFrequency (%) 
0800.9%
 
0.0001991< 0.1%
 
0.0011461< 0.1%
 
0.0012141< 0.1%
 
0.0012891< 0.1%
 
ValueCountFrequency (%) 
19043.138561< 0.1%
 
18495.558551< 0.1%
 
16304.889251< 0.1%
 
16259.448571< 0.1%
 
16115.59641< 0.1%
 

BALANCE_FREQUENCY
Real number (ℝ≥0)

Distinct43
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.8772707256
Minimum0
Maximum1
Zeros80
Zeros (%)0.9%
Memory size69.9 KiB
2021-05-22T22:41:59.859096image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.272727
Q10.888889
median1
Q31
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.111111

Descriptive statistics

Standard deviation0.2369040027
Coefficient of variation (CV)0.2700466296
Kurtosis3.092369622
Mean0.8772707256
Median Absolute Deviation (MAD)0
Skewness-2.023265519
Sum7851.572994
Variance0.05612350649
MonotocityNot monotonic
2021-05-22T22:42:00.034814image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%) 
1621169.4%
 
0.9090914104.6%
 
0.8181822783.1%
 
0.7272732232.5%
 
0.5454552192.4%
 
0.6363642092.3%
 
0.4545451721.9%
 
0.3636361701.9%
 
0.2727271511.7%
 
0.1818181461.6%
 
Other values (33)7618.5%
 
ValueCountFrequency (%) 
0800.9%
 
0.090909670.7%
 
0.180.1%
 
0.11111150.1%
 
0.12590.1%
 
ValueCountFrequency (%) 
1621169.4%
 
0.9090914104.6%
 
0.9550.6%
 
0.888889530.6%
 
0.875570.6%
 

PURCHASES
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct6203
Distinct (%)69.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1003.204834
Minimum0
Maximum49039.57
Zeros2044
Zeros (%)22.8%
Memory size69.9 KiB
2021-05-22T22:42:00.201797image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q139.635
median361.28
Q31110.13
95-th percentile3998.6195
Maximum49039.57
Range49039.57
Interquartile range (IQR)1070.495

Descriptive statistics

Standard deviation2136.634782
Coefficient of variation (CV)2.129809098
Kurtosis111.3887709
Mean1003.204834
Median Absolute Deviation (MAD)361.28
Skewness8.144269065
Sum8978683.26
Variance4565208.191
MonotocityNot monotonic
2021-05-22T22:42:00.380150image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0204422.8%
 
45.65270.3%
 
150160.2%
 
60160.2%
 
100130.1%
 
300130.1%
 
200130.1%
 
450120.1%
 
600100.1%
 
70100.1%
 
Other values (6193)677675.7%
 
ValueCountFrequency (%) 
0204422.8%
 
0.014< 0.1%
 
0.051< 0.1%
 
0.241< 0.1%
 
0.71< 0.1%
 
ValueCountFrequency (%) 
49039.571< 0.1%
 
41050.41< 0.1%
 
40040.711< 0.1%
 
38902.711< 0.1%
 
35131.161< 0.1%
 

ONEOFF_PURCHASES
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct4014
Distinct (%)44.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean592.4373709
Minimum0
Maximum40761.25
Zeros4302
Zeros (%)48.1%
Memory size69.9 KiB
2021-05-22T22:42:00.557848image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median38
Q3577.405
95-th percentile2671.094
Maximum40761.25
Range40761.25
Interquartile range (IQR)577.405

Descriptive statistics

Standard deviation1659.887917
Coefficient of variation (CV)2.801794753
Kurtosis164.187572
Mean592.4373709
Median Absolute Deviation (MAD)38
Skewness10.04508288
Sum5302314.47
Variance2755227.898
MonotocityNot monotonic
2021-05-22T22:42:00.725279image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0430248.1%
 
45.65460.5%
 
50170.2%
 
200150.2%
 
60130.1%
 
100130.1%
 
70120.1%
 
150120.1%
 
1000120.1%
 
250110.1%
 
Other values (4004)449750.2%
 
ValueCountFrequency (%) 
0430248.1%
 
0.0170.1%
 
0.022< 0.1%
 
0.051< 0.1%
 
0.241< 0.1%
 
ValueCountFrequency (%) 
40761.251< 0.1%
 
40624.061< 0.1%
 
34087.731< 0.1%
 
33803.841< 0.1%
 
26547.431< 0.1%
 

INSTALLMENTS_PURCHASES
Real number (ℝ≥0)

ZEROS

Distinct4452
Distinct (%)49.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean411.0676447
Minimum0
Maximum22500
Zeros3916
Zeros (%)43.8%
Memory size69.9 KiB
2021-05-22T22:42:00.901344image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median89
Q3468.6375
95-th percentile1750.0875
Maximum22500
Range22500
Interquartile range (IQR)468.6375

Descriptive statistics

Standard deviation904.3381152
Coefficient of variation (CV)2.199973963
Kurtosis96.57517753
Mean411.0676447
Median Absolute Deviation (MAD)89
Skewness7.299119909
Sum3679055.42
Variance817827.4266
MonotocityNot monotonic
2021-05-22T22:42:01.353729image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0391643.8%
 
100140.2%
 
300140.2%
 
200140.2%
 
150120.1%
 
125110.1%
 
7590.1%
 
22580.1%
 
35080.1%
 
45080.1%
 
Other values (4442)493655.2%
 
ValueCountFrequency (%) 
0391643.8%
 
1.951< 0.1%
 
4.441< 0.1%
 
4.81< 0.1%
 
6.331< 0.1%
 
ValueCountFrequency (%) 
225001< 0.1%
 
15497.191< 0.1%
 
14686.11< 0.1%
 
13184.431< 0.1%
 
12738.471< 0.1%
 

CASH_ADVANCE
Real number (ℝ≥0)

ZEROS

Distinct4323
Distinct (%)48.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean978.8711125
Minimum0
Maximum47137.21176
Zeros4628
Zeros (%)51.7%
Memory size69.9 KiB
2021-05-22T22:42:01.512311image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31113.821139
95-th percentile4647.169122
Maximum47137.21176
Range47137.21176
Interquartile range (IQR)1113.821139

Descriptive statistics

Standard deviation2097.163877
Coefficient of variation (CV)2.142431062
Kurtosis52.89943411
Mean978.8711125
Median Absolute Deviation (MAD)0
Skewness5.166609074
Sum8760896.457
Variance4398096.325
MonotocityNot monotonic
2021-05-22T22:42:01.671961image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0462851.7%
 
1286.3562071< 0.1%
 
3816.4702661< 0.1%
 
2495.2989261< 0.1%
 
748.2417271< 0.1%
 
1572.4927191< 0.1%
 
5425.9128071< 0.1%
 
9553.9559061< 0.1%
 
341.3608761< 0.1%
 
1424.4426021< 0.1%
 
Other values (4313)431348.2%
 
ValueCountFrequency (%) 
0462851.7%
 
14.2222161< 0.1%
 
18.0427681< 0.1%
 
18.1179671< 0.1%
 
18.1234131< 0.1%
 
ValueCountFrequency (%) 
47137.211761< 0.1%
 
29282.109151< 0.1%
 
27296.485761< 0.1%
 
26268.699891< 0.1%
 
26194.049541< 0.1%
 

PURCHASES_FREQUENCY
Real number (ℝ≥0)

ZEROS

Distinct47
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.4903505484
Minimum0
Maximum1
Zeros2043
Zeros (%)22.8%
Memory size69.9 KiB
2021-05-22T22:42:01.831436image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.083333
median0.5
Q30.916667
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.833334

Descriptive statistics

Standard deviation0.4013707474
Coefficient of variation (CV)0.8185383879
Kurtosis-1.638630948
Mean0.4903505484
Median Absolute Deviation (MAD)0.416667
Skewness0.06016423586
Sum4388.637408
Variance0.1610984768
MonotocityNot monotonic
2021-05-22T22:42:01.984608image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%) 
1217824.3%
 
0204322.8%
 
0.0833336777.6%
 
0.9166673964.4%
 
0.53954.4%
 
0.1666673924.4%
 
0.8333333734.2%
 
0.3333333674.1%
 
0.253453.9%
 
0.5833333163.5%
 
Other values (37)146816.4%
 
ValueCountFrequency (%) 
0204322.8%
 
0.0833336777.6%
 
0.090909430.5%
 
0.1270.3%
 
0.111111180.2%
 
ValueCountFrequency (%) 
1217824.3%
 
0.9166673964.4%
 
0.909091280.3%
 
0.9240.3%
 
0.888889180.2%
 

ONEOFF_PURCHASES_FREQUENCY
Real number (ℝ≥0)

ZEROS

Distinct47
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.2024576836
Minimum0
Maximum1
Zeros4302
Zeros (%)48.1%
Memory size69.9 KiB
2021-05-22T22:42:02.132460image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.083333
Q30.3
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.3

Descriptive statistics

Standard deviation0.2983360652
Coefficient of variation (CV)1.473572452
Kurtosis1.161845601
Mean0.2024576836
Median Absolute Deviation (MAD)0.083333
Skewness1.535612784
Sum1811.996268
Variance0.08900440779
MonotocityNot monotonic
2021-05-22T22:42:02.279941image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%) 
0430248.1%
 
0.083333110412.3%
 
0.1666675926.6%
 
14815.4%
 
0.254184.7%
 
0.3333333554.0%
 
0.4166672442.7%
 
0.52352.6%
 
0.5833331972.2%
 
0.6666671671.9%
 
Other values (37)8559.6%
 
ValueCountFrequency (%) 
0430248.1%
 
0.083333110412.3%
 
0.090909560.6%
 
0.1390.4%
 
0.111111260.3%
 
ValueCountFrequency (%) 
14815.4%
 
0.9166671511.7%
 
0.9090914< 0.1%
 
0.91< 0.1%
 
0.8888892< 0.1%
 

PURCHASES_INSTALLMENTS_FREQUENCY
Real number (ℝ≥0)

ZEROS

Distinct47
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.3644373416
Minimum0
Maximum1
Zeros3915
Zeros (%)43.7%
Memory size69.9 KiB
2021-05-22T22:42:02.427461image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.166667
Q30.75
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.75

Descriptive statistics

Standard deviation0.3974477797
Coefficient of variation (CV)1.090579187
Kurtosis-1.398632185
Mean0.3644373416
Median Absolute Deviation (MAD)0.166667
Skewness0.509201165
Sum3261.714207
Variance0.1579647376
MonotocityNot monotonic
2021-05-22T22:42:02.582900image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%) 
0391543.7%
 
1133114.9%
 
0.4166673884.3%
 
0.9166673453.9%
 
0.8333333113.5%
 
0.53103.5%
 
0.1666673053.4%
 
0.6666672923.3%
 
0.752913.3%
 
0.0833332753.1%
 
Other values (37)118713.3%
 
ValueCountFrequency (%) 
0391543.7%
 
0.0833332753.1%
 
0.090909120.1%
 
0.160.1%
 
0.11111190.1%
 
ValueCountFrequency (%) 
1133114.9%
 
0.9166673453.9%
 
0.909091250.3%
 
0.9190.2%
 
0.888889280.3%
 

CASH_ADVANCE_FREQUENCY
Real number (ℝ≥0)

ZEROS

Distinct54
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.1351442003
Minimum0
Maximum1.5
Zeros4628
Zeros (%)51.7%
Memory size69.9 KiB
2021-05-22T22:42:02.735044image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30.222222
95-th percentile0.583333
Maximum1.5
Range1.5
Interquartile range (IQR)0.222222

Descriptive statistics

Standard deviation0.2001213881
Coefficient of variation (CV)1.480798937
Kurtosis3.334734328
Mean0.1351442003
Median Absolute Deviation (MAD)0
Skewness1.828686266
Sum1209.540593
Variance0.04004856999
MonotocityNot monotonic
2021-05-22T22:42:02.880802image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0462851.7%
 
0.083333102111.4%
 
0.1666677598.5%
 
0.255786.5%
 
0.3333334394.9%
 
0.4166672733.1%
 
0.52152.4%
 
0.5833331421.6%
 
0.6666671251.4%
 
0.090909700.8%
 
Other values (44)7007.8%
 
ValueCountFrequency (%) 
0462851.7%
 
0.083333102111.4%
 
0.090909700.8%
 
0.1390.4%
 
0.111111290.3%
 
ValueCountFrequency (%) 
1.51< 0.1%
 
1.251< 0.1%
 
1.1666672< 0.1%
 
1.1428571< 0.1%
 
1.1251< 0.1%
 

CASH_ADVANCE_TRX
Real number (ℝ≥0)

ZEROS

Distinct65
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.248826816
Minimum0
Maximum123
Zeros4628
Zeros (%)51.7%
Memory size69.9 KiB
2021-05-22T22:42:03.032997image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q34
95-th percentile15
Maximum123
Range123
Interquartile range (IQR)4

Descriptive statistics

Standard deviation6.824646744
Coefficient of variation (CV)2.100649598
Kurtosis61.64686248
Mean3.248826816
Median Absolute Deviation (MAD)0
Skewness5.721298203
Sum29077
Variance46.57580318
MonotocityNot monotonic
2021-05-22T22:42:03.187997image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0462851.7%
 
18879.9%
 
26206.9%
 
34364.9%
 
43844.3%
 
53083.4%
 
62462.7%
 
72052.3%
 
81711.9%
 
101501.7%
 
Other values (55)91510.2%
 
ValueCountFrequency (%) 
0462851.7%
 
18879.9%
 
26206.9%
 
34364.9%
 
43844.3%
 
ValueCountFrequency (%) 
1233< 0.1%
 
1101< 0.1%
 
1071< 0.1%
 
931< 0.1%
 
801< 0.1%
 

PURCHASES_TRX
Real number (ℝ≥0)

ZEROS

Distinct173
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.7098324
Minimum0
Maximum358
Zeros2044
Zeros (%)22.8%
Memory size69.9 KiB
2021-05-22T22:42:03.348632image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median7
Q317
95-th percentile57
Maximum358
Range358
Interquartile range (IQR)16

Descriptive statistics

Standard deviation24.85764911
Coefficient of variation (CV)1.689866236
Kurtosis34.79310026
Mean14.7098324
Median Absolute Deviation (MAD)7
Skewness4.630655266
Sum131653
Variance617.9027193
MonotocityNot monotonic
2021-05-22T22:42:03.494968image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0204422.8%
 
16677.5%
 
125706.4%
 
23794.2%
 
63523.9%
 
33143.5%
 
42853.2%
 
72753.1%
 
82673.0%
 
52673.0%
 
Other values (163)353039.4%
 
ValueCountFrequency (%) 
0204422.8%
 
16677.5%
 
23794.2%
 
33143.5%
 
42853.2%
 
ValueCountFrequency (%) 
3581< 0.1%
 
3471< 0.1%
 
3441< 0.1%
 
3091< 0.1%
 
3081< 0.1%
 

CREDIT_LIMIT
Real number (ℝ≥0)

Distinct205
Distinct (%)2.3%
Missing1
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean4494.44945
Minimum50
Maximum30000
Zeros0
Zeros (%)0.0%
Memory size69.9 KiB
2021-05-22T22:42:03.646101image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum50
5-th percentile1000
Q11600
median3000
Q36500
95-th percentile12000
Maximum30000
Range29950
Interquartile range (IQR)4900

Descriptive statistics

Standard deviation3638.815725
Coefficient of variation (CV)0.8096243524
Kurtosis2.836655932
Mean4494.44945
Median Absolute Deviation (MAD)1800
Skewness1.522464005
Sum40220828.13
Variance13240979.88
MonotocityNot monotonic
2021-05-22T22:42:03.792532image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
30007848.8%
 
15007228.1%
 
12006216.9%
 
10006146.9%
 
25006126.8%
 
40005065.7%
 
60004635.2%
 
50003894.3%
 
20003714.1%
 
75002773.1%
 
Other values (195)359040.1%
 
ValueCountFrequency (%) 
501< 0.1%
 
15050.1%
 
2003< 0.1%
 
300140.2%
 
4003< 0.1%
 
ValueCountFrequency (%) 
300002< 0.1%
 
280001< 0.1%
 
250001< 0.1%
 
230002< 0.1%
 
225001< 0.1%
 

PAYMENTS
Real number (ℝ≥0)

ZEROS

Distinct8711
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1733.143852
Minimum0
Maximum50721.48336
Zeros240
Zeros (%)2.7%
Memory size69.9 KiB
2021-05-22T22:42:03.947203image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile89.98892395
Q1383.276166
median856.901546
Q31901.134317
95-th percentile6082.090595
Maximum50721.48336
Range50721.48336
Interquartile range (IQR)1517.858151

Descriptive statistics

Standard deviation2895.063757
Coefficient of variation (CV)1.670411693
Kurtosis54.77073581
Mean1733.143852
Median Absolute Deviation (MAD)581.3514605
Skewness5.907619794
Sum15511637.48
Variance8381394.157
MonotocityNot monotonic
2021-05-22T22:42:04.100630image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
02402.7%
 
806.5874821< 0.1%
 
836.8124141< 0.1%
 
139.6078271< 0.1%
 
107.2424081< 0.1%
 
433.8607141< 0.1%
 
402.200141< 0.1%
 
308.8864921< 0.1%
 
238.6951151< 0.1%
 
197.863491< 0.1%
 
Other values (8701)870197.2%
 
ValueCountFrequency (%) 
02402.7%
 
0.0495131< 0.1%
 
0.0564661< 0.1%
 
2.3895831< 0.1%
 
3.5005051< 0.1%
 
ValueCountFrequency (%) 
50721.483361< 0.1%
 
46930.598241< 0.1%
 
40627.595241< 0.1%
 
39461.96581< 0.1%
 
39048.597621< 0.1%
 

MINIMUM_PAYMENTS
Real number (ℝ≥0)

MISSING

Distinct8636
Distinct (%)> 99.9%
Missing313
Missing (%)3.5%
Infinite0
Infinite (%)0.0%
Mean864.2065423
Minimum0.019163
Maximum76406.20752
Zeros0
Zeros (%)0.0%
Memory size69.9 KiB
2021-05-22T22:42:04.255644image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0.019163
5-th percentile73.2820058
Q1169.123707
median312.343947
Q3825.485459
95-th percentile2766.56331
Maximum76406.20752
Range76406.18836
Interquartile range (IQR)656.361752

Descriptive statistics

Standard deviation2372.446607
Coefficient of variation (CV)2.745231019
Kurtosis283.9899859
Mean864.2065423
Median Absolute Deviation (MAD)190.374096
Skewness13.62279699
Sum7464151.906
Variance5628502.901
MonotocityNot monotonic
2021-05-22T22:42:04.421721image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
299.3518812< 0.1%
 
284.706931< 0.1%
 
144.6418141< 0.1%
 
1927.8875471< 0.1%
 
6825.442031< 0.1%
 
342.4124761< 0.1%
 
5583.6304821< 0.1%
 
125.34941< 0.1%
 
3.197941< 0.1%
 
140.5961381< 0.1%
 
Other values (8626)862696.4%
 
(Missing)3133.5%
 
ValueCountFrequency (%) 
0.0191631< 0.1%
 
0.0377441< 0.1%
 
0.055881< 0.1%
 
0.0594811< 0.1%
 
0.1170361< 0.1%
 
ValueCountFrequency (%) 
76406.207521< 0.1%
 
61031.61861< 0.1%
 
56370.041171< 0.1%
 
50260.759471< 0.1%
 
43132.728231< 0.1%
 

PRC_FULL_PAYMENT
Real number (ℝ≥0)

ZEROS

Distinct47
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.1537146485
Minimum0
Maximum1
Zeros5903
Zeros (%)66.0%
Memory size69.9 KiB
2021-05-22T22:42:04.588889image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30.142857
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.142857

Descriptive statistics

Standard deviation0.2924991962
Coefficient of variation (CV)1.902871321
Kurtosis2.432395301
Mean0.1537146485
Median Absolute Deviation (MAD)0
Skewness1.942819941
Sum1375.746104
Variance0.0855557798
MonotocityNot monotonic
2021-05-22T22:42:04.739624image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%) 
0590366.0%
 
14885.5%
 
0.0833334264.8%
 
0.1666671661.9%
 
0.251561.7%
 
0.51561.7%
 
0.0909091531.7%
 
0.3333331341.5%
 
0.1941.1%
 
0.2830.9%
 
Other values (37)119113.3%
 
ValueCountFrequency (%) 
0590366.0%
 
0.0833334264.8%
 
0.0909091531.7%
 
0.1941.1%
 
0.111111610.7%
 
ValueCountFrequency (%) 
14885.5%
 
0.916667770.9%
 
0.909091190.2%
 
0.9160.2%
 
0.888889120.1%
 

TENURE
Real number (ℝ≥0)

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.51731844
Minimum6
Maximum12
Zeros0
Zeros (%)0.0%
Memory size69.9 KiB
2021-05-22T22:42:04.862608image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum6
5-th percentile8
Q112
median12
Q312
95-th percentile12
Maximum12
Range6
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.338330769
Coefficient of variation (CV)0.1162015947
Kurtosis7.694823186
Mean11.51731844
Median Absolute Deviation (MAD)0
Skewness-2.943017288
Sum103080
Variance1.791129248
MonotocityNot monotonic
2021-05-22T22:42:04.963598image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
12758484.7%
 
113654.1%
 
102362.6%
 
62042.3%
 
81962.2%
 
71902.1%
 
91752.0%
 
ValueCountFrequency (%) 
62042.3%
 
71902.1%
 
81962.2%
 
91752.0%
 
102362.6%
 
ValueCountFrequency (%) 
12758484.7%
 
113654.1%
 
102362.6%
 
91752.0%
 
81962.2%
 

Interactions

2021-05-22T22:41:12.926752image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:13.107571image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:13.238338image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:13.365829image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:13.527724image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:13.670500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:13.803305image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:13.931513image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:14.177957image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:14.318481image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:14.462907image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:14.599684image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:14.743879image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:14.881815image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:15.010514image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:15.150426image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:15.281832image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:15.412527image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:15.540471image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:15.658345image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:15.778175image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:15.910194image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:16.027626image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:16.144086image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:16.263402image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:16.388052image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:16.515154image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:16.652900image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:16.775738image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:16.905752image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:17.034836image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:17.169844image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:17.313459image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:17.443181image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:17.575351image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:17.711871image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:17.838916image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:17.965773image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:18.104900image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:18.227852image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:18.346706image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:18.469039image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:18.597537image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:18.725269image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:18.858685image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:18.986073image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:19.119172image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:19.252887image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:19.497124image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:19.634337image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:19.762248image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:19.890470image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:20.039129image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:20.181970image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:20.326054image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:20.477178image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:20.615198image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:20.755068image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:20.897584image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:21.034620image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:21.171279image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:21.318882image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:21.461990image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:21.608651image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:21.753383image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:21.893125image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:22.047489image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:22.189064image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:22.328764image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:22.459739image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:22.583122image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:22.698746image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:22.828988image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:22.950149image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:23.068601image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:23.196559image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:23.320625image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:23.444436image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:23.575214image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:23.700347image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:23.835109image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:23.983525image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:24.111714image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:24.255470image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:24.401974image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:24.529994image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:24.677907image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:24.823117image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:24.972364image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:25.125093image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:25.247264image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:25.372866image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:25.516027image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:25.645060image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:25.770626image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:25.909807image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:26.044044image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:26.344991image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:26.479044image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:26.599595image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:26.734337image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:26.854600image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:26.984388image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:27.137734image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:27.271432image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:27.401200image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:27.539458image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:27.662686image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:27.785582image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:27.930962image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:28.089830image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:28.228508image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:28.358864image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:28.481238image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:28.613034image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:28.745359image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:28.868649image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:29.000440image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:29.125035image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:29.255899image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:29.417910image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:29.565296image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:29.715854image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:29.872996image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:30.007522image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:30.145506image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:30.291176image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:30.427797image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:30.577964image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:30.721635image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:30.865502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:31.025418image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:31.193265image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:31.336619image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:31.490485image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:31.634453image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:31.785180image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:31.923145image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:32.068378image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:32.227372image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:32.379708image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:32.536433image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:32.677294image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:32.819608image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:32.961355image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:33.107733image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:33.259058image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:33.426353image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:33.574277image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:33.726821image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:33.880281image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:34.101346image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:34.346999image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:34.510827image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:34.673423image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:34.818860image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:34.970129image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:35.135112image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:35.515417image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:35.679622image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:36.001187image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:36.772436image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:37.058765image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:37.288489image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:37.449791image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:37.634575image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:37.851697image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:38.058945image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:38.301780image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:38.528099image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:38.760381image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:39.040432image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:39.299510image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:39.701857image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:39.887189image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:40.032749image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:40.173704image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:40.321826image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:40.479029image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:40.788987image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:41.002063image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:41.168875image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:41.348556image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:41.539343image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:41.734730image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:41.925517image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:42.080125image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:42.234337image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:42.404320image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:42.576379image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:42.757648image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:42.923184image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:43.080645image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:43.228677image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:43.379473image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:43.527832image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:43.679422image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:43.829969image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:43.974406image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:44.169540image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:44.338502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:44.490440image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:44.697770image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:44.841507image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:44.981343image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:45.123494image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:45.257742image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:45.401771image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:45.550593image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:45.690172image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:45.872041image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:46.044715image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:46.211421image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:46.348584image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:46.497876image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:46.641457image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:46.816155image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:47.008194image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:47.161993image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:47.318925image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:47.459878image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:47.604574image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:47.750717image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:47.890776image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:48.026118image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:48.176363image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:48.304630image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:48.424466image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:48.559585image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:48.691290image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:48.824476image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:49.220566image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:49.363750image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:49.501394image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:49.641052image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:49.775111image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:49.918035image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:50.046653image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:50.177194image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:50.345766image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:50.493233image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:50.634865image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:50.805713image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:50.991068image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:51.168309image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:51.346907image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:51.548151image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:51.848270image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:52.070331image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:52.226289image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:52.378048image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:52.535863image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:52.689930image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:52.847592image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:53.001209image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:53.162446image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:53.301935image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:53.446965image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:53.586207image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:53.737698image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:53.878517image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:54.005978image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:54.142552image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:54.289361image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:54.424014image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:54.561933image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:54.694718image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:54.829365image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:54.951970image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:55.070070image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:55.200643image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:55.318807image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:55.439977image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:55.571679image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:55.700502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:55.848490image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:55.996894image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:56.143726image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:56.281462image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:56.419341image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:56.555615image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:56.694873image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:56.840167image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:56.990257image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:57.139800image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:57.286633image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:57.430656image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:57.582300image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:57.719377image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Correlations

2021-05-22T22:42:05.104588image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2021-05-22T22:42:05.398979image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2021-05-22T22:42:05.684901image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2021-05-22T22:42:05.986235image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2021-05-22T22:41:58.050268image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:58.475221image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:58.740940image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2021-05-22T22:41:58.866253image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Sample

First rows

CUST_IDBALANCEBALANCE_FREQUENCYPURCHASESONEOFF_PURCHASESINSTALLMENTS_PURCHASESCASH_ADVANCEPURCHASES_FREQUENCYONEOFF_PURCHASES_FREQUENCYPURCHASES_INSTALLMENTS_FREQUENCYCASH_ADVANCE_FREQUENCYCASH_ADVANCE_TRXPURCHASES_TRXCREDIT_LIMITPAYMENTSMINIMUM_PAYMENTSPRC_FULL_PAYMENTTENURE
0C1000140.9007490.81818295.400.0095.400.0000000.1666670.0000000.0833330.000000021000.0201.802084139.5097870.00000012
1C100023202.4674160.9090910.000.000.006442.9454830.0000000.0000000.0000000.250000407000.04103.0325971072.3402170.22222212
2C100032495.1488621.000000773.17773.170.000.0000001.0000001.0000000.0000000.0000000127500.0622.066742627.2847870.00000012
3C100041666.6705420.6363641499.001499.000.00205.7880170.0833330.0833330.0000000.083333117500.00.000000NaN0.00000012
4C10005817.7143351.00000016.0016.000.000.0000000.0833330.0833330.0000000.000000011200.0678.334763244.7912370.00000012
5C100061809.8287511.0000001333.280.001333.280.0000000.6666670.0000000.5833330.000000081800.01400.0577702407.2460350.00000012
6C10007627.2608061.0000007091.016402.63688.380.0000001.0000001.0000001.0000000.00000006413500.06354.314328198.0658941.00000012
7C100081823.6527431.000000436.200.00436.200.0000001.0000000.0000001.0000000.0000000122300.0679.065082532.0339900.00000012
8C100091014.9264731.000000861.49661.49200.000.0000000.3333330.0833330.2500000.000000057000.0688.278568311.9634090.00000012
9C10010152.2259750.5454551281.601281.600.000.0000000.1666670.1666670.0000000.0000000311000.01164.770591100.3022620.00000012

Last rows

CUST_IDBALANCEBALANCE_FREQUENCYPURCHASESONEOFF_PURCHASESINSTALLMENTS_PURCHASESCASH_ADVANCEPURCHASES_FREQUENCYONEOFF_PURCHASES_FREQUENCYPURCHASES_INSTALLMENTS_FREQUENCYCASH_ADVANCE_FREQUENCYCASH_ADVANCE_TRXPURCHASES_TRXCREDIT_LIMITPAYMENTSMINIMUM_PAYMENTSPRC_FULL_PAYMENTTENURE
8940C19181130.8385541.000000591.240.00591.240.0000001.0000000.0000000.8333330.000000061000.0475.52326282.7713201.006
8941C191825967.4752700.833333214.550.00214.558555.4093260.8333330.0000000.6666670.6666671359000.0966.202912861.9499060.006
8942C1918340.8297491.000000113.280.00113.280.0000001.0000000.0000000.8333330.000000061000.094.48882886.2831010.256
8943C191845.8717120.50000020.9020.900.000.0000000.1666670.1666670.0000000.00000001500.058.64488343.4737170.006
8944C19185193.5717220.8333331012.731012.730.000.0000000.3333330.3333330.0000000.000000024000.00.000000NaN0.006
8945C1918628.4935171.000000291.120.00291.120.0000001.0000000.0000000.8333330.000000061000.0325.59446248.8863650.506
8946C1918719.1832151.000000300.000.00300.000.0000001.0000000.0000000.8333330.000000061000.0275.861322NaN0.006
8947C1918823.3986730.833333144.400.00144.400.0000000.8333330.0000000.6666670.000000051000.081.27077582.4183690.256
8948C1918913.4575640.8333330.000.000.0036.5587780.0000000.0000000.0000000.16666720500.052.54995955.7556280.256
8949C19190372.7080750.6666671093.251093.250.00127.0400080.6666670.6666670.0000000.3333332231200.063.16540488.2889560.006